IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spCustomersInsert')
	BEGIN
		DROP  PROCEDURE  spCustomersInsert
	END
GO
-- =============================================
-- Author:		<NamTP>
-- Create date: <Apr 24, 2012>
-- Description:	<Get Company List Infomation>
-- TEST: EXEC spCustomersInsert 17,2,''
-- =============================================
CREATE PROCEDURE spCustomersInsert
	   @CustomerID NCHAR(5)
      ,@CompanyName NVARCHAR(40)
      ,@ContactName NVARCHAR(30)
      ,@ContactTitle NVARCHAR(30)
      ,@Address NVARCHAR(60)
      ,@City NVARCHAR(15)
      ,@Region NVARCHAR(15)
      ,@PostalCode NVARCHAR(10)
      ,@Country NVARCHAR(15)
      ,@Phone NVARCHAR(24)
      ,@Fax NVARCHAR(24)
AS
BEGIN
	INSERT INTO Customers ([CustomerID]
      ,[CompanyName]
      ,[ContactName]
      ,[ContactTitle]
      ,[Address]
      ,[City]
      ,[Region]
      ,[PostalCode]
      ,[Country]
      ,[Phone]
      ,[Fax])
	VALUES(@CustomerID
      ,@CompanyName
      ,@ContactName
      ,@ContactTitle
      ,@Address
      ,@City
      ,@Region
      ,@PostalCode
      ,@Country
      ,@Phone
      ,@Fax)
END
GO
